The problem is occurring because INSTR is giving you the position of the '-' within the text. To fix this you can just add or subtract 1 ... ... <看更多>

Using Substr and Instr We can extract any string from a Text/Column,. ... substr in Sql | SUBSTR function in Oracle | INSTR in SQL | SQL ... ... <看更多>

Also, the in sql operator is intended to work on sets rather than strings. If your tableA has an ID, you can try the following query instead: ... <看更多>